package com.example.sqllite;

import com.sql.helper.DBService;

import android.support.v4.widget.SimpleCursorAdapter;
import android.support.v7.app.ActionBarActivity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.ListView;

public class MainActivity extends ActionBarActivity {
   private ListView lv1;
   DBService db;
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		lv1=(ListView) findViewById(R.id.lv1);
		showdata();
	}
	
	

	private void showdata() {
		 Cursor cursor=db.GetCursorData(1, 5);
		 String[] itemname={"name","age","sex"};
		 int[] itemid={R.id.name,R.id.age,R.id.sex};
		 SimpleCursorAdapter sca=new SimpleCursorAdapter(getApplicationContext(), R.layout.iteam, cursor, itemname, itemid);
		 
		 lv1.setAdapter(sca);
	}



	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.main, menu);
		return true;
	}

	@Override
	public boolean onOptionsItemSelected(MenuItem item) {
		// Handle action bar item clicks here. The action bar will
		// automatically handle clicks on the Home/Up button, so long
		// as you specify a parent activity in AndroidManifest.xml.
		int id = item.getItemId();
		if (id == R.id.action_settings) {
			return true;
		}
		return super.onOptionsItemSelected(item);
	}
}
